Tips.NetExcelRibbon.Tips.Net - Powerful tips on using Microsoft Excel Microsoft Windows Tips - Windows.Tips.Net Tips.net Household Tips, Handy Hints, and Thrifty Ideas WordRibbon.Tips.Net - Powerful tips on using Microsoft Word
Tips.Net (Excelribbon.Tips.Net by Allen Wyatt )A Shortcut for Switching Focus Aborting a Macro and Retaining Control Accepting Only a Single Digit Accessing Dependent and Precedent Information Activating the Formula Bar with the Keyboard Adding a Calendar to a Worksheet Adding a Comment to Multiple Cells Adding a Custom Format to those Offered by Excel Adding a File Path and Filename Adding a Macro to the Quick Access Toolbar Adding a Missing Closing Bracket Adding a ScreenTip Adding a Statement Showing an Automatic Row Count Adding a Tool to Clear Borders Adding and Formatting a Shape via Macro Adding Area Codes to Phone Numbers Adding Comments to Protected Worksheets Adding Dashes between Letters Adding Differently Formatted Text to a Cell Adding Drop Shadows Adding Last-Row Data to a Page Footer Adding Leading Zeroes to ZIP Codes Adding Ordinal Notation to Dates Adding Spaces in Front of Capital Letters Adding the Set Print Area Tool Adding the Set Print Area Tool Adding Up Tops and Bottoms Adjusting a Path Based on System and User Adjusting Cell Margins for More White Space Adjusting Center Across Selection with a Cell Value Adjusting Comment Printouts Adjusting Formulas for Top-Added Rows Adjusting Formulas when Pasting Adjusting Row Height for a Number of Worksheets Adjusting Spell Check for Internet Addresses Adjusting Status Bar Font Size Adjusting Times for Time Zones Adjusting to a Maximum Row Height Adjusting to a Maximum Row Height Adjusting Values with Formulas Adjusting Your View of 3-D Graphs Advanced Filtering Advancing Dates to a New Year Ages in Years and Months Alerts About Approaching Due Dates Aligning Cells when Importing from CSV Allowing for Prefixes and Suffixes in Find and Replace Allowing for Prefixes and Suffixes in Find and Replace Allowing for Words that Contain Numbers Alphabetic Column Designation Alphabetizing Worksheet Tabs Alphabetizing Worksheet Tabs Alt+Enter Stopped Working Correctly Altering the Displayed Format of Numbers to the Nearest 100 Always Open at 100% Zoom Always Opening a Workbook that is Editable An Average that Excludes Zero Values Anchoring Comment Boxes in Desired Locations Animated Recalculation in Excel Appending to a Non-Excel Text File Applying Range Names to Formulas Applying Table Formats Arranging Workbook Windows Assigning Macros to Graphics AutoFill Won't Work as Expected AutoFilling Numbers with a Trailing Period AutoFilling with Weekdays Automatic Row Height for Wrapped Text Automatic Selection of Portrait or Landscape Automatic Text in an E-mail Automatically Adding 20% to an Entry Automatically Advancing by a Month Automatically Advancing by a Month Automatically Breaking Text Automatically Breaking Text Automatically Capitalizing Day Names Automatically Changing a Cell's Background Color Automatically Converting to GMT Automatically Copying Formatting Automatically Displaying Thumbnails of a Graphic File Automatically Enabling Macros for Specific Workbooks Automatically Entering a Data Entry Time Automatically Formatting for Decimal Places Automatically Formatting for Decimal Places Automatically Hiding the Personal Workbook Automatically Loading Add-ins Automatically Moving from Cell to Cell when Entering Data Automatically Numbering Rows Automatically Placing Text in a Comment Automatically Protecting After Input Automatically Renaming Worksheets Automating the Importing of Macros Averaging Based on Multiple Criteria Averaging Values for a Given Month and Year Averaging without Hidden Cells Avoiding Rounding Errors in Formula Results Backing Up Custom Dictionaries Backing Up Quick Access Toolbars Backwards Date Parsing Black and White Blues Breaking Up Variable-Length Part Numbers Bypassing the BeforeClose Event Calculating a Group Retirement Date Calculating a Sum for a Range of Dates Calculating an Age On a Given Date Calculating an Age On a Given Date Calculating an Average Time Calculating an ISBN Check Digit Calculating Averages by Date Calculating Business Days Calculating Combinations Calculating Differences in Months using Non-Standard Date Values Calculating Elapsed Time with Excluded Periods Calculating Fractions of Years Calculating Future Workdays Calculating Months for Billing Purposes Calculating Months of Tenure Calculating Only the Active Workbook Calculating Statistical Values on Different-Sized Subsets of Data Calculating the Day of the Year Calculating the Distance between the Top of the Window and Row 1 Calculating the First Tuesday Calculating the Last Day in a Week Number Calculating TV Time Calculating Week-Ending Dates Calculating Weekend Dates Calling a Macro from the Workbook_Open Event Calling a Subroutine from a UDF Can't Access the Registry Can't Copy Data between Workbooks Can't Set Custom Format in VBA Can't Sort Imported Data Can't Use Hyperlinks Cannot Add Worksheets to a Workbook Capitalizing Just a Surname Cell Address of a Maximum Value Cell Address of a Maximum Value Cell and Name References in COUNTIF Cell and Name References in COUNTIF Cell Movement After Enter Change characters in cells Changes in Font Size when Copying Changing an Invalid Autosave Folder Changing Cell Values while Printing Changing Cell Values while Printing Changing Control Panel Views Changing Currency Formatting for a Single Workbook Changing Default Row Height Changing Directories in a Macro Changing Elements in Lots of Charts at One Time Changing Error Checking Rules Changing Excel's Starting Date Changing Font Face and Size Conditionally Changing Fonts in Multiple Workbooks Changing Gridline Color Changing Huge Numbers of Hyperlinks Changing Limited Relative References to Absolute Changing Links Changing Macro Cell References Based on Edits Changing Months in a Workbook Changing Months in a Workbook Changing Multiple Cells at Once Changing Multiple Cells at Once Changing Number Display Settings for Single Workbooks Changing Number Display Settings for Single Workbooks Changing Page Number Format Changing Paper Size for a Complete Workbook Changing Paper Size for a Complete Workbook Changing Portions of Many Hyperlinks Changing Portions of Many Hyperlinks Changing References in a Lot of Defined Names Changing Section Headers Changing Shading when a Column Value Changes Changing Text in Text Boxes on a Chart Changing the Axis Scale Changing the Background Color for a Comment Changing the Color of a Cell Border Changing the Color of Worksheet Gridlines Changing the Comment Font Changing the Comment Indicator Color Changing the Cycling Sequence for the F4 Cell Reference Shortcut Changing the Default Drive Changing the Default Drive Changing the Default Font Changing the Default Paste Mode Changing the Default Text Import Delimiter Changing the Default Vertical Alignment Changing the Outline Color of the Selected Cell Changing the Percent Symbol Changing the Reference in a Named Range Changing the Ribbon's Size and Look Changing the Size of a Graphic Changing the Start Screen's Theme Changing to a Non-US Date Format Changing Width and Height to Inches Changing Width and Height to Inches Changing Your Name Character display characters ASCI Checking for a Value in a Cell Checking for an Entry in a Cell Checking for Either of Two Text Values Checking for Proper Entry of Array Formulas Checking for Text Checking for the Existence of a File Checking for Time Input Checking if a Workbook is Already Open Checking Lock Status of Cells Checking the Scope of a Defined Name Choosing Direction after Enter On a Workbook Basis Choosing Direction after Enter On a Workbook Basis Cleaning Text Clearing and Deleting Cells Clearing and Deleting Cells Clearing Everything Except Formulas Clearing Large Clipboard Entries Clearing Only Filtering Settings Clearing the Clipboard in a Macro Clearing the Print Area Clearing the Undo Stack in a Macro Closing a Read-Only Workbook Closing Excel when Closing the Last Workbook Collating Copies Coloring Identical Company Names Colors - Converting HSL to RGB Column Formatting Based On a Filter Combinations for Members in Meetings Combinations for Members in Meetings Combining Cell Contents Combining Columns Combining Columns Combining Multiple Rows in a Column Combining Numbers and Text in a Cell Comma-Delimited and MS-DOS CSV Variations Comma-Delimited Differences for PC and Mac Comparing Formulas on Two Worksheets Complex Data Input Limitations Concatenating Values from a Variable Number of Cells Condensing Sequential Values to a Single Row Conditional Formats for Odd and Even Columns Conditional Formats that Distinguish Blanks and Zeroes